package com.example.wdanzuobq;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class NoteDatabase extends SQLiteOpenHelper{

    public static final String TABLE_NAME = "notes";
    public static final String CONTENT = "content";
    public static final String ID = "_id";
    public static final String TIME = "time";
    public static final String MODE = "mode";

    public NoteDatabase(Context context){
        super(context, "notes",null,1);
    }

    @Override
    public void onCreate(SQLiteDatabase db){
        db.execSQL("CREATE TABLE "+TABLE_NAME
        +"("
        + ID + "INTEGER PRIMARY KEY AUTOINCREMENT,"
        + CONTENT + "TEXTNOTNULL,"
        + TIME + "TEXT NOT NULL,"
        + MODE + "INTEGER DEFAULT 1)"
        );
    }
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion){
        /*for (int i = oldVersion; i < newVersion;i++){
            switch (i){
                case 1:
                break;
                case 2:
                    updateMode(db);
                default:break;

            }
        }*/
    }
}
